Computer science Lesson Plan
Class: 5 - Lesson:6 Spreadsheet (Basics of spreadsheet and Properties of cells)

Purpose:Learn about row, column,cell and cell address,insert / delete a row,a column & a new sheet,rename a sheet. Students should learn the editing operations and properties of cell in spreadsheet.

No. of Classes

One class.

Material Required

Open office (Spreadsheet).

Curriculum Content
  • 7) Open office - Spread sheet
  • 7.1) Spread sheet basics
  • 7.2) Cell properties
    •

    Prior knowledge

    Students should know about basics of spreadsheet.

    Exercise

    Exercise:1


    1.What do you mean by spreadsheet? Explain the uses of spreadsheets.

    Exercise:2


    2.Insert a new sheet and delete sheet -2 in the spreadsheet and rename the sheet-3.

    Exercise:3


    3.Students should copy an image and paste it in a new spreadsheet file and save the spreadsheet file.

    Exercise:4


    4. Change the cell color of the following cells as specified: D13 to Green, G18 to Red, and J7 to Violet.

    No Image

    Solution


  • Link to view the solutions video for exercise-1 & 2.
  • Link to view the solution video for excercise-3.
  • Link to view the solution video for excercise-4.

    • Teacher's Instruction
    1. Teachers should ensure that Students practice all the feature
    2. Explain the row number and column name in Spreadsheet
    3. Differentiate spreadsheets and text documents.
    4. Explain about autofill feature and its usage in filling dates, days & S. No.
    5. Make them to understand inserting / moving / renaming a new sheet.
    6. While teaching use the words like row, column, cells, sheet etc. They need to be familiar with those words .
    7. Teachers should teach the all the basic properties of cell.
    8. Teachers can allow students to complete the exercise in a group.